package com.ruoyi.wxdaiqu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.wxdaiqu.pojo.Anlysis;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author 有手就行
 */
public interface AnlysisMapper extends BaseMapper<Anlysis> {
    @Select("select * from anlysis where wx_id = #{wxId}")
    Anlysis byWxId(Integer wxId);

    @Select("SELECT * FROM anlysis WHERE YEAR(create_time) = #{year} AND MONTH(create_time) = #{month} AND wx_id = #{wxId}")
    Anlysis byCreateTime(@Param("wxId") Integer wxId,@Param("year") String year,@Param("month") String month);
}
